package models.mappers;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import models.DeviceModel;

public interface DeviceModelMapper {
	/**
	 * 获取型号下拉框
	 *
	 * @Title: getCombobox 
	 * @return
	 * @return: List<DeviceModel>
	 */
	@Select("select modelid,modelname from "
			+ DeviceModel.TABLE_NAME
			+" where isflag=false")
	List<DeviceModel> getCombobox();
	/**
	 * 根据id查询型号信息
	 *
	 * @Title: getById 
	 * @param modelid
	 * @return
	 * @return: DeviceModel
	 */
	@Select("select * from "
			+ DeviceModel.TABLE_NAME
			+" where modelid=#{modelid}")
	DeviceModel getById(String modelid);
	
}
